ALTER TABLE [dbo].[CadServicoOS_Inform]
ADD [Unit] money
GO

ALTER TABLE [dbo].[CadServicoOS_Inform]
ADD [Codigo] Varchar(50)
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [UN] varchar(3) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[VendaDados]
ADD [NCM] varchar(50)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [CodCidade] varchar(20)
GO

ALTER TABLE [dbo].[Orcamentos]
ADD [TotalCusto] money
GO

ALTER TABLE [dbo].[OrcamentosDados]
ADD [ValorCusto] money
GO

ALTER TABLE [dbo].[OrcamentosDados]
ADD [TotalCusto] money
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [Numero] varchar(10)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [PontoReferencia] varchar(100)
GO

--------------------------------

ALTER TABLE [dbo].[TempProd]
ALTER COLUMN [CodBarras] varchar(100) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[TempProd]
ADD [Codigo] varchar(50)
GO

-------------------------------------------

ALTER TABLE [dbo].[Parametro]
ADD [PontoRef] varchar(3)
GO



ALTER TABLE [dbo].[LancBancario]
ADD [Tipo] varchar(15)
GO
--------------------------------------



ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha1] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha2] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha3] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha4] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha5] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha6] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha7] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha8] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha9] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha10] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha11] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha12] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha13] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha14] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha15] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha16] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Impresso]
ALTER COLUMN [Linha17] varchar(80) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[ContasReceber]
ADD [Praca] varchar(50)
GO


ALTER TABLE [dbo].[Parametro]
ADD [Mensagem] varchar(30)
GO


ALTER TABLE [dbo].[Temporario]
ADD [Vendedor] varchar(50)
GO



CREATE TABLE [dbo].[TempCliente] (
  [ID] int,
  [Cliente] varchar(200)
)
GO

05/03/2012

ALTER TABLE [dbo].[CadCFOP]
ALTER COLUMN [ICMS] money
GO


ALTER TABLE [dbo].[CadCFOP]
ADD [CSOSN] varchar(10)
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QtdEstoque] money
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial01] money
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial02] money
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantCD] money
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial09] money
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial08] money
GO

ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial03] money
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial04] money
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial07] money
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial06] money
GO


ALTER TABLE [dbo].[Cad_prod]
ALTER COLUMN [QuantFilial05] money
GO

ALTER TABLE [dbo].[CadCFOP]
ADD [COFINS] money
GO


ALTER TABLE [dbo].[Cad_prod]
ADD [ECF] varchar(5)
GO


---- 04/04/2012

ALTER TABLE [dbo].[Empresa]
ADD [ECF] varchar(15)
GO

ALTER TABLE [dbo].[Empresa]
ADD [MensagemECF] varchar(40)
GO


----- 02/05/2012

ALTER TABLE [dbo].[Parametro]
ADD [Ficha] varchar(3)
GO


ALTER TABLE [dbo].[LancBancario]
ADD [Operador] varchar(100)
GO


------- 05/05/2012 --- lembre-se que junto com o executvel agora voc deve levar o arquivo "TraduoDev.ini' para q a agenda fique em portugues

CREATE TABLE [dbo].[cxSchedulerResourcesTable] (
  [ResourceID] int IDENTITY(1, 1) NOT NULL,
  [ResourceColor] int,
  [ResourceName] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [ResourceImageIndex] int,
  [Inicio] varchar(8) COLLATE Latin1_General_CI_AS,
  [Fim] varchar(8) COLLATE Latin1_General_CI_AS
)
ON [PRIMARY]
GO


CREATE TABLE [dbo].[cxSchedulerTable] (
  [ID] int IDENTITY(1, 1) NOT NULL,
  [ParentID] int,
  [Type] int,
  [Start] datetime,
  [Finish] datetime,
  [Options] int,
  [Caption] varchar(255) COLLATE Latin1_General_CI_AS,
  [RecurrenceIndex] int,
  [Location] varchar(255) COLLATE Latin1_General_CI_AS,
  [Message] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [ReminderDate] datetime,
  [ReminderMinutes] int,
  [State] int,
  [LabelColor] int,
  [ActualStart] datetime,
  [ActualFinish] datetime,
  [SyncIDField] varchar(255) COLLATE Latin1_General_CI_AS,
  [ResourceID] varbinary(max),
  [RecurrenceInfo] varbinary(max)
)
ON [PRIMARY]
GO


12/05/2012 ---------------------------------------

ALTER TABLE [dbo].[IndiceParcelas]
ADD [ID] int IDENTITY(1, 1) NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[IndiceParcelas]
ALTER COLUMN [ID] int NOT NULL
GO

ALTER TABLE [dbo].[IndiceParcelas]
ADD CONSTRAINT [IndiceParcelas_pk] PRIMARY KEY ([ID])
GO


02/06/2012 -----------------------------------------


CREATE TABLE [dbo].[Cad_Vendedor] (
  [Codigo] int NOT NULL,
  [Nome] varchar(100) COLLATE Latin1_General_CI_AS NOT NULL,
  [Apelido] varchar(30) COLLATE Latin1_General_CI_AS,
  [Cidade] varchar(30) COLLATE Latin1_General_CI_AS,
  [CEP] varchar(13) COLLATE Latin1_General_CI_AS,
  [Endereco] varchar(100) COLLATE Latin1_General_CI_AS,
  [Bairro] varchar(30) COLLATE Latin1_General_CI_AS,
  [Telefone] varchar(15) COLLATE Latin1_General_CI_AS,
  [Telefone2] varchar(15) COLLATE Latin1_General_CI_AS,
  [InfFone] varchar(50) COLLATE Latin1_General_CI_AS,
  [Celular] varchar(15) COLLATE Latin1_General_CI_AS,
  [CelularTH] varchar(15) COLLATE Latin1_General_CI_AS,
  [DataNasc] datetime,
  [RG] varchar(15) COLLATE Latin1_General_CI_AS,
  [CPF-CNPJ] varchar(15) COLLATE Latin1_General_CI_AS,
  [CTPS] varchar(20) COLLATE Latin1_General_CI_AS,
  [PIS] varchar(20) COLLATE Latin1_General_CI_AS,
  [CatCNH] varchar(2) COLLATE Latin1_General_CI_AS,
  [CNH] varchar(15) COLLATE Latin1_General_CI_AS,
  [ValCNH] datetime,
  [Cargo] varchar(80) COLLATE Latin1_General_CI_AS,
  [Pessoa] varchar(8) COLLATE Latin1_General_CI_AS,
  [DataAdmissao] datetime,
  [DataInicioTrabalho] datetime,
  [NomePai] varchar(100) COLLATE Latin1_General_CI_AS,
  [NomeMae] varchar(100) COLLATE Latin1_General_CI_AS,
  [EstCivil] varchar(20) COLLATE Latin1_General_CI_AS,
  [TemDependentes] varchar(3) COLLATE Latin1_General_CI_AS,
  [Informdependetes] varchar(250) COLLATE Latin1_General_CI_AS,
  [Naturalidade] varchar(80) COLLATE Latin1_General_CI_AS,
  [Nacionalidade] varchar(80) COLLATE Latin1_General_CI_AS,
  [STATUS] varchar(20) COLLATE Latin1_General_CI_AS,
  [DataDemissao] datetime,
  [NomeBanco] varchar(30) COLLATE Latin1_General_CI_AS,
  [Agencia] varchar(18) COLLATE Latin1_General_CI_AS,
  [TipoConta] varchar(2) COLLATE Latin1_General_CI_AS,
  [Titular] varchar(50) COLLATE Latin1_General_CI_AS,
  [NumConta] varchar(25) COLLATE Latin1_General_CI_AS,
  [NumCartaoUnimed] varchar(18) COLLATE Latin1_General_CI_AS,
  [InicioContratoUnimed] datetime,
  [TipoPlanoUnimed] varchar(30) COLLATE Latin1_General_CI_AS,
  [TemDepUnimed] char(1) COLLATE Latin1_General_CI_AS,
  [NomeDepUnimed] varchar(250) COLLATE Latin1_General_CI_AS,
  [Valor] real,
  [Conjuge] varchar(50) COLLATE Latin1_General_CI_AS,
  [CodigoBarras] varchar(80) COLLATE Latin1_General_CI_AS,
  [Horario] varchar(80) COLLATE Latin1_General_CI_AS,
  [Manha1] varchar(8) COLLATE Latin1_General_CI_AS,
  [Manha2] varchar(8) COLLATE Latin1_General_CI_AS,
  [Almoco1] varchar(8) COLLATE Latin1_General_CI_AS,
  [Almoco2] varchar(8) COLLATE Latin1_General_CI_AS,
  [Tarde1] varchar(8) COLLATE Latin1_General_CI_AS,
  [Tarde2] varchar(8) COLLATE Latin1_General_CI_AS,
  [Saida1] varchar(8) COLLATE Latin1_General_CI_AS,
  [Saida2] varchar(8) COLLATE Latin1_General_CI_AS,
  [Salario] real,
  [Senha] varchar(50) COLLATE Latin1_General_CI_AS
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[Cad_Vendedor]
ADD PRIMARY KEY CLUSTERED ([Codigo])
WITH (
  PAD_INDEX = OFF,
  IGNORE_DUP_KEY = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[Cad_Vendedor]
ADD [ComissaoVista] money
GO


ALTER TABLE [dbo].[Cad_Vendedor]
ADD [ComissaoPrazo] money
GO

28-08-2012

ALTER TABLE [dbo].[RankingProd]
ADD [Valor] money
GO

ALTER TABLE [dbo].[RankingProd]
ADD [Total] money
GO

-------------------------

06/09/12

ALTER TABLE [dbo].[Empresa]
ADD [Site] varchar(150)
GO

ALTER TABLE [dbo].[Empresa]
ADD [Email] varchar(150)
GO

ALTER TABLE [dbo].[Transportadora]
ADD [UFPlaca] varchar(2)
GO


---------------------

15/09/2012

ALTER TABLE [dbo].[Cad_OS_Inform]
ADD [CodCliente] varchar(15)
GO

ALTER TABLE [dbo].[Cad_OS_Inform]
ADD [CodAtendente] varchar(15)
GO

ALTER TABLE [dbo].[Cad_OS_Inform]
ADD [CodTecnico] varchar(15)
GO

----------------------------

22/09/2012

ALTER TABLE [dbo].[VendaDados]
ADD [Operador] varchar(100)
GO



---------------------------------
26/10/2012

ALTER TABLE [dbo].[Cad_prod]
ADD [MVA] money
GO


ALTER TABLE [dbo].[VendaDados]
ADD [MVA] money
GO


CREATE TABLE [dbo].[ICMS] (
  [ID] int,
  [UFLocal] varchar(10) COLLATE Latin1_General_CI_AS,
  [UFDestino] varchar(10) COLLATE Latin1_General_CI_AS,
  [MVA] money,
  [ICMS] money,
  [ICMSSUBST] money
)
ON [PRIMARY]
GO


---------------------------------
21-11/2012

CREATE TABLE [dbo].[VendaEstorno] (
  [Cliente] varchar(255) COLLATE Latin1_General_CI_AS,
  [FoneCliente] varchar(25) COLLATE Latin1_General_CI_AS,
  [FaxCliente] varchar(25) COLLATE Latin1_General_CI_AS,
  [Data] datetime,
  [Vendedor] varchar(200) COLLATE Latin1_General_CI_AS,
  [DescontoReal] money,
  [DescontoCento] money,
  [TotalGeral] money,
  [FormaPGTO] varchar(25) COLLATE Latin1_General_CI_AS,
  [Parcelas] varchar(100) COLLATE Latin1_General_CI_AS,
  [CodigoVenda] int IDENTITY(1, 1) NOT NULL,
  [Status] varchar(20) COLLATE Latin1_General_CI_AS,
  [Observacao] varchar(1000) COLLATE Latin1_General_CI_AS,
  [QuemAtende] varchar(80) COLLATE Latin1_General_CI_AS,
  [CFOP1] varchar(180) COLLATE Latin1_General_CI_AS,
  [CFOP] varchar(10) COLLATE Latin1_General_CI_AS,
  [InscSubstEst] varchar(50) COLLATE Latin1_General_CI_AS,
  [Numero1] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero2] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero3] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero4] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero5] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero6] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero7] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero8] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero9] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero10] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero11] varchar(20) COLLATE Latin1_General_CI_AS,
  [Numero12] varchar(20) COLLATE Latin1_General_CI_AS,
  [Vencimento1] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento2] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento3] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento4] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento5] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento6] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento7] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento8] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento9] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento10] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento11] varchar(10) COLLATE Latin1_General_CI_AS,
  [Vencimento12] varchar(10) COLLATE Latin1_General_CI_AS,
  [Valor1] real,
  [Valor2] real,
  [Valor3] real,
  [Valor4] real,
  [Valor5] real,
  [Valor6] real,
  [Valor7] real,
  [Valor8] real,
  [Valor9] real,
  [Valor10] real,
  [Valor11] real,
  [Valor12] real,
  [Comissao] real,
  [ValorICMS] real,
  [ValorFrete] real,
  [ValorIPI] real,
  [Transportadora] varchar(80) COLLATE Latin1_General_CI_AS,
  [FreteConta] varchar(1) COLLATE Latin1_General_CI_AS,
  [PlacaVeiculo] varchar(18) COLLATE Latin1_General_CI_AS,
  [CGCTransportadora] varchar(20) COLLATE Latin1_General_CI_AS,
  [EnderecoTransportadora] varchar(100) COLLATE Latin1_General_CI_AS,
  [CidadeTransportadora] varchar(100) COLLATE Latin1_General_CI_AS,
  [InscEstTransportadora] varchar(20) COLLATE Latin1_General_CI_AS,
  [QuantTransportadora] real,
  [EspecieTransportadora] varchar(25) COLLATE Latin1_General_CI_AS,
  [MarcaTransportadora] varchar(50) COLLATE Latin1_General_CI_AS,
  [NumTransportadora] varchar(20) COLLATE Latin1_General_CI_AS,
  [PesoTransportadora] real,
  [PesoLiquidoTransportadora] real,
  [DadosAdicionais] varchar(1000) COLLATE Latin1_General_CI_AS,
  [Lucro] money,
  [BaseCalculo] real,
  [Status2] varchar(200) COLLATE Latin1_General_CI_AS,
  [CodPedido] varchar(50) COLLATE Latin1_General_CI_AS,
  [Filial] varchar(100) COLLATE Latin1_General_CI_AS,
  [Transmitido] varchar(3) COLLATE Latin1_General_CI_AS,
  [Mesa] varchar(3) COLLATE Latin1_General_CI_AS,
  [HoraEntrada] varchar(8) COLLATE Latin1_General_CI_AS,
  [PrevisaoSaida] varchar(8) COLLATE Latin1_General_CI_AS,
  [Entregador] varchar(150) COLLATE Latin1_General_CI_AS,
  [LocalXML] varchar(800) COLLATE Latin1_General_CI_AS,
  [Codigo] int,
  [CSOSN] varchar(15) COLLATE Latin1_General_CI_AS,
  [CRN] varchar(50) COLLATE Latin1_General_CI_AS,
  [IPICST] varchar(50) COLLATE Latin1_General_CI_AS,
  [PISCST] varchar(20) COLLATE Latin1_General_CI_AS,
  [COFINSCST] varchar(50) COLLATE Latin1_General_CI_AS
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[VendaEstorno]
ADD CONSTRAINT [VendaEstorno_new_new_new_pk]  
PRIMARY KEY CLUSTERED ([CodigoVenda])
WITH (
  PAD_INDEX = OFF,
  IGNORE_DUP_KEY = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

---------------------------------------------------------------------
13/12/12


CREATE TABLE [dbo].[Romaneio] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [DataEmissao] datetime,
  [Fornecedor] varchar(150),
  [Produto] varchar,
  [QtdVolumes] real,
  [TaraSaca] real,
  [ValorSaca] money,
  [PesoBruto] real,
  [PeloLiquido] real,
  [ValorTotalBruto] money,
  [DataEntrega] datetime,
  [NumNR] varchar(50),
  [Funrural] money,
  [ValorFunrural] money,
  [Adiantamento] money,
  [TotalRomaneio] money,
  [Corretor] varchar(150),
  [NumDocumento] varchar(50),
  [Obs] varchar(800),
  PRIMARY KEY CLUSTERED ([ID])
)
GO


ALTER TABLE [dbo].[Cad_prod]
ADD [Broca] money
GO

ALTER TABLE [dbo].[Cad_prod]
ADD [Umidade] money
GO


ALTER TABLE [dbo].[Cad_prod]
ADD [Fundo] money
GO


ALTER TABLE [dbo].[Cad_prod]
ADD [Impureza] money
GO

ALTER TABLE [dbo].[Cad_prod]
ADD [QTDDefeitos] money
GO



ALTER TABLE [dbo].[Romaneio]
ADD [Broca] money
GO

ALTER TABLE [dbo].[Romaneio]
ADD [Umidade] money
GO


ALTER TABLE [dbo].[Romaneio]
ADD [Fundo] money
GO


ALTER TABLE [dbo].[Romaneio]
ADD [Impureza] money
GO

ALTER TABLE [dbo].[Romaneio]
ADD [QTDDefeitos] money
GO


ALTER TABLE [dbo].[Romaneio]
ALTER COLUMN [Produto] varchar(150) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cad_prod]
ADD [Funrural] money
GO

--------- 15/01/2013

ALTER TABLE [dbo].[Venda]
ADD [NumNFE] int
GO

---------- 01/02/2013

ALTER TABLE [dbo].[Parametro]
ADD [FiscalRemoto] varchar(3)
GO

---------- 07/02/2013

CREATE TABLE [dbo].[Rec] (
  [CODIGO] int,
  [NomeDevedor] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Valor] float(53),
  [ValoEx] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Data] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Referente] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Via] int,
  [Cidade] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Estado] nvarchar(2) COLLATE Latin1_General_CI_AS
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Recibo] (
  [Numero] int,
  [Nome] nvarchar(50) COLLATE Latin1_General_CI_AS,
  [Valor_Ex] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Referente] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [Valor] float(53)
)
ON [PRIMARY]
GO


-------------- 15/03/2013

ALTER TABLE [dbo].[Recibo]
ADD [Tipo] varchar(20)
GO

ALTER TABLE [dbo].[Rec]
ADD [Tipo] varchar(20)
GO

--------------- 27/03/2013

ALTER TABLE [dbo].[Romaneio]
ADD [Status] varchar(50)
GO

--------------------
11/04/2013

CREATE TABLE [dbo].[RomaneioDeposito] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [DataEmissao] datetime,
  [Fornecedor] varchar(150) COLLATE Latin1_General_CI_AS,
  [Produto] varchar(150) COLLATE Latin1_General_CI_AS,
  [QtdVolumes] real,
  [TaraSaca] real,
  [PesoBruto] real,
  [PesoLiquido] real,
  [DataEntrega] datetime,
  [NumNR] varchar(50) COLLATE Latin1_General_CI_AS,
  [Funrural] money,
  [ValorFunrural] money,
  [NumDocumento] varchar(50) COLLATE Latin1_General_CI_AS,
  [Obs] varchar(800) COLLATE Latin1_General_CI_AS,
  [Broca] money,
  [Umidade] money,
  [Fundo] money,
  [Impureza] money,
  [QTDDefeitos] money,
  [Status] varchar(50) COLLATE Latin1_General_CI_AS,
  [Associacao] varchar(200) COLLATE Latin1_General_CI_AS,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO

-----------------------------
10/05/2013

ALTER TABLE [dbo].[Empresa]
ADD [CSOSN] varchar(10)
GO

ALTER TABLE [dbo].[Empresa]
ADD [TipoPIS] varchar(10)
GO

ALTER TABLE [dbo].[Empresa]
ADD [TipoIPI] varchar(10)
GO

ALTER TABLE [dbo].[Empresa]
ADD [TipoCOFINS] varchar(10)
GO


------------------------------------
05/08/2013

ALTER TABLE [dbo].[Empresa]
ADD [Usuario] varchar(50)
GO

ALTER TABLE [dbo].[Empresa]
ADD [Senha] varchar(50)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [Bloqueio] varchar(3)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [SerialHD] varchar(50)
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [TrocaSerial] int
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [UserOS] varchar(100)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [Senha] varchar(30)
GO

-------------------------------------

CREATE TABLE [dbo].[PlanoContas] (
  [Cod_conta] nvarchar(15) COLLATE Latin1_General_CI_AS,
  [Reduzido] int,
  [Descricao] nvarchar(45) COLLATE Latin1_General_CI_AS,
  [Grupo] nvarchar(1) COLLATE Latin1_General_CI_AS,
  [Nivel] nvarchar(1) COLLATE Latin1_General_CI_AS,
  [Tipo] nvarchar(1) COLLATE Latin1_General_CI_AS,
  [Origem] nvarchar(1) COLLATE Latin1_General_CI_AS,
  [Conta_pai] nvarchar(15) COLLATE Latin1_General_CI_AS,
  [Debitos] float(53),
  [Creditos] float(53),
  [Anterior] float(53),
  [Atual] float(53),
  [DRE] nvarchar(5) COLLATE Latin1_General_CI_AS,
  [field1] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  CONSTRAINT [PlanoContas_pk] PRIMARY KEY CLUSTERED ([field1])
)
ON [PRIMARY]
GO

----------------------------------------------

ALTER TABLE [dbo].[Venda]
ADD [NFE] varchar(200)
GO

05-08-2014

ALTER TABLE [dbo].[CadServicoOS_Inform]
ALTER COLUMN [Quant] money
GO


ALTER TABLE [dbo].[CadServicoOS]
ALTER COLUMN [Qtd] money
GO

22 - 08 2014


ALTER TABLE [dbo].[Cad_OS_Inform]
ADD [Indice] int IDENTITY(1, 1) NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[Cad_OS_Inform]
ALTER COLUMN [Indice] int NOT NULL
GO

ALTER TABLE [dbo].[Cad_OS_Inform]
ADD CONSTRAINT [Cad_OS_Inform_pk] PRIMARY KEY ([Indice])
GO


02 09 2014

ALTER TABLE [dbo].[Cli_Fornec]
ALTER COLUMN [RG-InscEst] varchar(50) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Cli_Fornec]
ALTER COLUMN [RG] varchar(35) COLLATE Latin1_General_CI_AS
GO



15 09 2014

ALTER TABLE [dbo].[Comissao]
ADD [Qtd] money
GO


24 09 2014

CREATE TABLE [dbo].[Comissao_Agrupada] (
  [Descricao] varchar(150) COLLATE Latin1_General_CI_AS,
  [Valor] real,
  [Indice] varchar(10) COLLATE Latin1_General_CI_AS,
  [Comissao_Agrupada] real,
  [Venda] real,
  [Codigo] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [Tipo] varchar(10) COLLATE Latin1_General_CI_AS,
  [Qtd] money
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[Comissao_Agrupada]
ADD CONSTRAINT [Comissao_Agrupada_new_pk]  
PRIMARY KEY CLUSTERED ([Codigo])
WITH (
  PAD_INDEX = OFF,
  IGNORE_DUP_KEY = OFF,
  STATISTICS_NORECOMPUTE = OFF,
  ALLOW_ROW_LOCKS = ON,
  ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

10 12 2014

ALTER TABLE [dbo].[Cad_usu]
ADD [Estornar] varchar(3)
GO


ALTER TABLE [dbo].[Cad_usu]
ADD [Demonstrativo] varchar(3)
GO


19 12 2014

ALTER TABLE [dbo].[Parametro]
ADD [PedirObs] varchar(3)
GO


ALTER TABLE [dbo].[Parametro]
ADD [DescEntregador] varchar(50)
GO

02 04 2015

ALTER TABLE [dbo].[Cli_Fornec]
ADD [IsentoIE] varchar(3)
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [ConsFinal] varchar(3)
GO

06 08 2015

ALTER TABLE [dbo].[Venda]
ADD [Finalidade] varchar(30)
GO

ALTER TABLE [dbo].[Venda]
ADD [JustRef] varchar(255)
GO


ALTER TABLE [dbo].[Venda]
ADD [NfeRef] varchar(50)
GO



------ 04/07/2016


ALTER TABLE [dbo].[Cli_Fornec]
ADD [Observacao] varchar(500)
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [IDGrupo] int
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [UserOS] varchar(100) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [Senha] varchar(30) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [TipoCliente] varchar(10) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [Foto] image
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [Dia] int
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [CreditoPromocao] money
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [FilialCliente] varchar(200) COLLATE Latin1_General_CI_AS
GO



ALTER TABLE [dbo].[Cli_Fornec]
ADD [DataCadastro] datetime
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [Categoria] varchar(50) COLLATE Latin1_General_CI_AS
GO

ALTER TABLE [dbo].[Cli_Fornec]
ADD [EnderecoCobranca] varchar(200) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [CidadeCobranca] varchar(50) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [BairroCobranca] varchar(50) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [PorcentagemPromo] money
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [IncideST] varchar(3) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [DataRegistro] datetime
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [Vendedor2] varchar(50) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [EnderecoEntrega] varchar(150) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [NumEntrega] varchar(20) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [BairroEntrega] varchar(50) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [CodCidadeEntrega] varchar(25) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [CidadeEntrega] varchar(50) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [UFEntrega] varchar(2) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [CEPEntrega] varchar(10) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [ConsumidorFinal] varchar(3) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Cli_Fornec]
ADD [Complemento] varchar(120) COLLATE Latin1_General_CI_AS
GO



CREATE TABLE [dbo].[TabelaPreco] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [Descricao] varchar(50) COLLATE Latin1_General_CI_AS,
  [IPI] money,
  [PIS] money,
  [CSTPis] varchar(20) COLLATE Latin1_General_CI_AS,
  [CSTIpi] varchar(20) COLLATE Latin1_General_CI_AS,
  [COFINS] money,
  [CSTCofins] varchar(20) COLLATE Latin1_General_CI_AS,
  [ReducaoIPI] money,
  [ReducaoPIS] money,
  [ReducaoCOFINS] money,
  [ReducaoIPIMenor] money,
  [ReducaoPISMenor] money,
  [ReducaoCOFINSMenor] money,
  [CSOSN] varchar(8) COLLATE Latin1_General_CI_AS,
  [CSOSNST] varchar(8) COLLATE Latin1_General_CI_AS,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO





ALTER TABLE [dbo].[Cad_prod]
ADD [IPR] varchar(100) COLLATE Latin1_General_CI_AS,
  [Lote] varchar(100) COLLATE Latin1_General_CI_AS,
  [Peneira] varchar(100) COLLATE Latin1_General_CI_AS,
  [Germinacao] varchar(100) COLLATE Latin1_General_CI_AS,
  [Validade] varchar(100) COLLATE Latin1_General_CI_AS,
  [Safra] varchar(50) COLLATE Latin1_General_CI_AS,
  [QTDReal] money,
  [Campo] varchar(100) COLLATE Latin1_General_CI_AS,
  [Boletim] varchar(50) COLLATE Latin1_General_CI_AS,
  [Termo] varchar(50) COLLATE Latin1_General_CI_AS,
  [Vigor] varchar(50) COLLATE Latin1_General_CI_AS,
  [Area] float(53),
  [Plantio] datetime,
  [Colheita] datetime,
  [Beneficiamento] datetime,
  [DataInscCampo] datetime,
  [QtdAnalisado] float(53),
  [ScAnalisado] float(53),
  [DataTermo] datetime,
  [QtdSacas] float(53),
  [PesoSaca] float(53),
  [TipoProduto] varchar(10) COLLATE Latin1_General_CI_AS,
  [Promocional] varchar(3) COLLATE Latin1_General_CI_AS,
  [GeraCredito] varchar(3) COLLATE Latin1_General_CI_AS,
  [ValorCredito] money,
  [Pauta] money,
  [ValorPauta] money,
  [ICMSST] varchar(5) COLLATE Latin1_General_CI_AS,
  [PautaFederal] money,
  [CSTPis] varchar(15) COLLATE Latin1_General_CI_AS,
  [CSTCofins] varchar(10) COLLATE Latin1_General_CI_AS,
  [CSTIpi] varchar(10) COLLATE Latin1_General_CI_AS,
  [SubGrupo] varchar(50) COLLATE Latin1_General_CI_AS,
  [UsarReducao] varchar(5) COLLATE Latin1_General_CI_AS,
  [CFOPLocal] varchar(5) COLLATE Latin1_General_CI_AS,
  [CFOPInterestadual] varchar(5) COLLATE Latin1_General_CI_AS,
  [CFOPLocalST] varchar(5) COLLATE Latin1_General_CI_AS,
  [CFOPInterestadualST] varchar(5) COLLATE Latin1_General_CI_AS,
  [CSOSNST] varchar(10) COLLATE Latin1_General_CI_AS,
  [Colecao] varchar(130) COLLATE Latin1_General_CI_AS,
  [Impresso] varchar(1) COLLATE Latin1_General_CI_AS,
  [CEST] varchar(30) COLLATE Latin1_General_CI_AS,
  [Fornecedor] varchar(180) COLLATE Latin1_General_CI_AS
  GO


CREATE TABLE [dbo].[Pagamentos] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [NumVenda] int,
  [FormaPGTO] varchar(200) COLLATE Latin1_General_CI_AS,
  [Valor] money,
  [Tipo] varchar(50) COLLATE Latin1_General_CI_AS,
  [Data] datetime,
  [ECF] varchar(10) COLLATE Latin1_General_CI_AS,
  [Parcelas] varchar(50) COLLATE Latin1_General_CI_AS,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO




ALTER TABLE [dbo].[Brindes]
ADD [NumVenda] int,
  [Qtd] money,
  [Unit] money
GO


CREATE TABLE [dbo].[EtiquetaNF] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [Cliente] varchar(150) COLLATE Latin1_General_CI_AS,
  [Endereco] varchar(150) COLLATE Latin1_General_CI_AS,
  [Cidade] varchar(150) COLLATE Latin1_General_CI_AS,
  [UF] varchar(2) COLLATE Latin1_General_CI_AS,
  [CEP] varchar(10) COLLATE Latin1_General_CI_AS,
  [QtdVolumes] int,
  [NumVolume] int,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO



ALTER TABLE [dbo].[NFEletr]
ADD [IDEmpresa] varchar(20)
GO



ALTER TABLE [dbo].[ICMS]
ADD [Reducao] money
GO



ALTER TABLE [dbo].[ICMS]
ADD [Diferimento] money
GO


CREATE TABLE [dbo].[TempFinanceiro] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [Data] datetime,
  [Total] money,
  [Cliente] varchar(150) COLLATE Latin1_General_CI_AS,
  CONSTRAINT [TempFinanceiro_pk] PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO



CREATE TABLE [dbo].[TempContas] (
  [ID] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [CodCliFornec] int,
  [Nome] varchar(200) COLLATE Latin1_General_CI_AS,
  PRIMARY KEY CLUSTERED ([ID])
)
ON [PRIMARY]
GO


CREATE TABLE [dbo].[TempPlanoContas] (
  [Descricao] nvarchar(255) COLLATE Latin1_General_CI_AS,
  [field1] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [Valor] money,
  CONSTRAINT [TempPlanoContas_pk] PRIMARY KEY CLUSTERED ([field1])
)
ON [PRIMARY]
GO


 

ALTER TABLE [dbo].[ContasReceber]
ADD [Filial] varchar(150) COLLATE Latin1_General_CI_AS,
  [CodCli] int,
  [EmitenteCheque] varchar(100) COLLATE Latin1_General_CI_AS,
  [NumCheque] varchar(30) COLLATE Latin1_General_CI_AS,
  [CNPJCPFCheque] varchar(25) COLLATE Latin1_General_CI_AS,
  [EmissaoCheque] datetime,
  [VencimentoCheque] datetime,
  [BancoCheque] varchar(80) COLLATE Latin1_General_CI_AS,
  [ContaCheque] varchar(50) COLLATE Latin1_General_CI_AS,
  [AgenciaCheque] varchar(30) COLLATE Latin1_General_CI_AS,
  [ValorDescontoDuplicata] money,
  [ValorDesconto] money,
  [NumNFE] varchar(15) COLLATE Latin1_General_CI_AS,
  [JurosTotais] money,
  [JurosManuais] varchar(5) COLLATE Latin1_General_CI_AS,
  [StatusCheque] varchar(10) COLLATE Latin1_General_CI_AS
GO




ALTER TABLE [dbo].[Cad_Func]
ADD [Observacao] varchar(800) COLLATE Latin1_General_CI_AS,
  [Selecionado] varchar(1) COLLATE Latin1_General_CI_AS,
  [Comissao] money,
  [Email] varchar(200) COLLATE Latin1_General_CI_AS
GO




ALTER TABLE [dbo].[ContasPagar]
ADD [Filial] varchar(150) COLLATE Latin1_General_CI_AS,
  [Tipo] varchar(5) COLLATE Latin1_General_CI_AS
GO


ALTER TABLE [dbo].[Representantes]
ADD [Indice] money
GO




ALTER TABLE [dbo].[Venda]
ADD [DestinoOperacao] varchar(100)
GO




ALTER TABLE [dbo].[Venda]
ADD [VendaPresencial] varchar(5)
GO



ALTER TABLE [dbo].[Venda]
ADD [TagPgto] varchar(20)
GO



ALTER TABLE [dbo].[Venda]
ADD [FinalidadeNFE] varchar(200)
GO




ALTER TABLE [dbo].[Venda]
ADD [OutrosValores] money
GO


ALTER TABLE [dbo].[Venda]
ADD [ValorSeguro] money
GO



ALTER TABLE [dbo].[Venda]
ADD [FinalidadeNFE] varchar(30)
GO



ALTER TABLE [dbo].[Venda]
ADD [InformFisco] varchar(200)
GO



ALTER TABLE [dbo].[Venda]
ADD [ChaveNFERef] varchar(100)
GO



ALTER TABLE [dbo].[NCM]
ALTER COLUMN [COD_NCM] int NOT NULL
GO


ALTER TABLE [dbo].[LancBancario]
ADD [TipoConta] varchar(50)
GO



ALTER TABLE [dbo].[LancBancario]
ADD [IDConta] varchar(50)
GO